drop processingdate	// variable for version control only
drop clientid		// single-valued, pretty sure it means us

* destring IDs
destring medid, replace
destring ddi, replace

* format period as a monthly variable
gen m = ym(real(substr(period,1,4)), real(substr(period,-2,2)))
format m %tm
drop period
